HW3 Data set 12; life expectancy and income

loading in needed libraries:

loading in needed data:

Reshape ‘Income Per Person’ to make a longitudinal dataset such that the resulting dataset has three columns: country, year, and income

reshape pop total

Reshape ‘Life Expectancy in Years’ such that the resulting dataset has columns country, year, and life expectancy

Merge the two datsets above into a new one called LifeExpIncom that has the following variables: country, year, lifeExp, and income

Merge LifeExpIncom with country region so that the final dataset has info about income, life expectancy, and country region.

Make an interactive scatter plot to display the association between life expectancy and income for the year 2015. - point size to be proportional to the population size – might need to rescale for it to look appropriate - different colors for different countries - Include the country name and population size in the hover text

#filter to the year 2015
LEIP_f_15 <- LEIP_f%>%filter(year==2015)
LEIP_f_15
##                            country income life expectancy    pop_num   region
## 1                      Afghanistan   1750            57.9   33700000     Asia
## 2                          Albania  11000            77.6    2920000   Europe
## 3                          Algeria  13700            77.3   39900000   Africa
## 4                          Andorra  46600            82.5      78000   Europe
## 5                           Angola   6230            64.0   27900000   Africa
## 6              Antigua and Barbuda  20100            77.2      99900 Americas
## 7                        Argentina  19100            76.5   43400000 Americas
## 8                          Armenia   8180            75.4    2920000     Asia
## 9                        Australia  43800            82.6   23800000  Oceania
## 10                         Austria  44100            81.4    8680000   Europe
## 11                      Azerbaijan  16700            71.8    9620000     Asia
## 12                         Bahamas  21700            73.6     387000 Americas
## 13                         Bahrain  44500            76.8    1370000     Asia
## 14                      Bangladesh   3130            72.4  161000000     Asia
## 15                        Barbados  15400            76.6     284000 Americas
## 16                         Belarus  17200            73.3    9490000   Europe
## 17                         Belgium  41700            80.9   11300000   Europe
## 18                          Belize   8060            71.9     359000 Americas
## 19                           Benin   1990            63.9   10600000   Africa
## 20                          Bhutan   7740            73.8     787000     Asia
## 21          Bosnia and Herzegovina  10900            77.4    3540000   Europe
## 22                        Botswana  15400            64.6    2210000   Africa
## 23                          Brazil  14700            75.2  206000000 Americas
## 24                        Bulgaria  17000            75.0    7180000   Europe
## 25                    Burkina Faso   1550            60.3   18100000   Africa
## 26                         Burundi    749            60.0   10200000   Africa
## 27                        Cambodia   3290            68.3   15500000     Asia
## 28                        Cameroon   2990            59.7   22800000   Africa
## 29                          Canada  43000            81.7   35900000 Americas
## 30        Central African Republic    626            49.7    4550000   Africa
## 31                            Chad   2050            59.2   14000000   Africa
## 32                           Chile  22500            80.1   17800000 Americas
## 33                           China  13600            76.3 1400000000     Asia
## 34                        Colombia  13000            78.0   48200000 Americas
## 35                         Comoros   1410            67.3     777000   Africa
## 36                Congo, Dem. Rep.    750            60.9   76200000   Africa
## 37                      Costa Rica  14900            80.9    4810000 Americas
## 38                   Cote d'Ivoire   3250            59.2   23100000   Africa
## 39                         Croatia  20600            77.3    4240000   Europe
## 40                            Cuba  20000            78.9   11500000 Americas
## 41                          Cyprus  30400            80.5    1160000     Asia
## 42                  Czech Republic  30400            78.9   10600000   Europe
## 43                         Denmark  45500            80.7    5690000   Europe
## 44                        Djibouti   3140            66.1     927000   Africa
## 45                        Dominica  10100            71.7      73200 Americas
## 46              Dominican Republic  13400            75.5   10500000 Americas
## 47                         Ecuador  10800            77.9   16100000 Americas
## 48                           Egypt  10100            71.9   93800000   Africa
## 49                     El Salvador   7850            75.0    6310000 Americas
## 50               Equatorial Guinea  27200            65.2    1180000   Africa
## 51                         Eritrea   1240            63.4    4850000   Africa
## 52                         Estonia  27300            77.2    1320000   Europe
## 53                        Ethiopia   1530            65.2   99900000   Africa
## 54                            Fiji   8760            65.5     892000  Oceania
## 55                         Finland  39000            81.5    5480000   Europe
## 56                          France  37800            82.2   64500000   Europe
## 57                           Gabon  16800            66.0    1930000   Africa
## 58                          Gambia   1590            67.0    1980000   Africa
## 59                         Georgia   9030            73.7    3950000     Asia
## 60                         Germany  43800            80.8   81700000   Europe
## 61                           Ghana   3930            65.4   27600000   Africa
## 62                          Greece  24100            81.0   11200000   Europe
## 63                         Grenada  12700            71.4     107000 Americas
## 64                       Guatemala   7290            72.5   16300000 Americas
## 65                          Guinea   1180            60.0   12100000   Africa
## 66                   Guinea-Bissau   1420            58.2    1770000   Africa
## 67                          Guyana   7060            67.0     769000 Americas
## 68                           Haiti   1650            63.9   10700000 Americas
## 69                        Honduras   4310            72.5    8960000 Americas
## 70                         Hungary  24800            75.7    9780000   Europe
## 71                         Iceland  42700            82.2     330000   Europe
## 72                           India   5750            68.2 1310000000     Asia
## 73                       Indonesia  10400            71.4  258000000     Asia
## 74                            Iraq  14900            67.6   36100000     Asia
## 75                         Ireland  60900            81.1    4700000   Europe
## 76                          Israel  32000            82.0    8060000     Asia
## 77                           Italy  34200            82.3   59500000   Europe
## 78                         Jamaica   8110            74.9    2870000 Americas
## 79                           Japan  37800            83.8  128000000     Asia
## 80                          Jordan   8490            76.8    9160000     Asia
## 81                           Kenya   2840            66.3   47200000   Africa
## 82                        Kiribati   1870            61.6     112000  Oceania
## 83                          Kuwait  69300            79.8    3940000     Asia
## 84                 Kyrgyz Republic   3240            71.1    5870000     Asia
## 85                          Latvia  23100            74.8    1990000   Europe
## 86                         Lebanon  13100            80.1    5850000     Asia
## 87                         Lesotho   2780            49.6    2170000   Africa
## 88                         Liberia    785            63.8    4500000   Africa
## 89                           Libya  13500            74.2    6230000   Africa
## 90                       Lithuania  27000            74.9    2930000   Europe
## 91                      Luxembourg  95300            82.0     567000   Europe
## 92                      Madagascar   1380            62.3   24200000   Africa
## 93                          Malawi   1090            59.4   17600000   Africa
## 94                        Malaysia  25000            75.4   30700000     Asia
## 95                        Maldives  12000            79.3     418000     Asia
## 96                            Mali   1920            61.4   17500000   Africa
## 97                           Malta  34400            81.3     428000   Europe
## 98                Marshall Islands   3670            64.7      53000  Oceania
## 99                      Mauritania   3600            70.0    4180000   Africa
## 100                      Mauritius  18900            74.5    1260000   Africa
## 101                         Mexico  16700            76.2  126000000 Americas
## 102                       Mongolia  11400            68.2    2980000     Asia
## 103                     Montenegro  15300            76.9     628000   Europe
## 104                        Morocco   7290            74.8   34800000   Africa
## 105                     Mozambique   1120            59.0   28000000   Africa
## 106                        Myanmar   5070            69.5   52400000     Asia
## 107                        Namibia   9910            64.3    2430000   Africa
## 108                          Nepal   2300            69.7   28700000     Asia
## 109                    Netherlands  46400            81.6   16900000   Europe
## 110                    New Zealand  34600            81.5    4610000  Oceania
## 111                      Nicaragua   4960            78.0    6080000 Americas
## 112                          Niger    897            61.2   19900000   Africa
## 113                        Nigeria   5670            64.0  181000000   Africa
## 114                    North Korea   1390            70.6   25200000     Asia
## 115                         Norway  63700            82.1    5200000   Europe
## 116                           Oman  40100            77.4    4200000     Asia
## 117                       Pakistan   4700            67.3  189000000     Asia
## 118                      Palestine   2650            71.8    4660000     Asia
## 119                         Panama  20700            78.7    3970000 Americas
## 120               Papua New Guinea   2750            60.5    7920000  Oceania
## 121                       Paraguay   8640            74.4    6640000 Americas
## 122                           Peru  11800            79.5   31400000 Americas
## 123                    Philippines   6880            70.1  102000000     Asia
## 124                         Poland  25300            77.7   38300000   Europe
## 125                       Portugal  26500            80.8   10400000   Europe
## 126                          Qatar 120000            80.5    2480000     Asia
## 127                        Romania  20500            75.1   19900000   Europe
## 128                         Russia  24100            70.8  144000000   Europe
## 129                         Rwanda   1720            67.3   11600000   Africa
## 130                          Samoa   5560            71.7     194000  Oceania
## 131          Sao Tome and Principe   2940            70.3     196000   Africa
## 132                   Saudi Arabia  50700            76.8   31600000     Asia
## 133                        Senegal   2300            65.9   15000000   Africa
## 134                         Serbia  13300            75.7    8850000   Europe
## 135                     Seychelles  25500            73.7      93700   Africa
## 136                   Sierra Leone   1320            57.6    7240000   Africa
## 137                      Singapore  80900            83.6    5540000     Asia
## 138                Slovak Republic  28300            76.8    5440000   Europe
## 139                       Slovenia  29100            80.7    2070000   Europe
## 140                Solomon Islands   2050            62.8     587000  Oceania
## 141                        Somalia    623            57.3   13900000   Africa
## 142                   South Africa  12400            61.8   55300000   Africa
## 143                    South Korea  34200            80.9   50600000     Asia
## 144                    South Sudan   1810            58.9   11900000   Africa
## 145                          Spain  32200            82.9   46400000   Europe
## 146                      Sri Lanka  11100            77.2   20700000     Asia
## 147                      St. Lucia  10700            76.1     177000 Americas
## 148 St. Vincent and the Grenadines  10500            71.6     109000 Americas
## 149                          Sudan   4290            68.0   38600000   Africa
## 150                       Suriname  14800            71.2     553000 Americas
## 151                         Sweden  45500            82.1    9760000   Europe
## 152                    Switzerland  56500            83.1    8320000   Europe
## 153                          Syria   3500            68.4   18700000     Asia
## 154                     Tajikistan   2640            71.6    8550000     Asia
## 155                       Tanzania   2490            63.5   53900000   Africa
## 156                       Thailand  15200            77.6   68700000     Asia
## 157                    Timor-Leste   2150            72.6    1240000     Asia
## 158                           Togo   1350            62.1    7420000   Africa
## 159                          Tonga   5190            70.3     106000  Oceania
## 160            Trinidad and Tobago  31300            73.1    1360000 Americas
## 161                        Tunisia  10800            77.4   11300000   Africa
## 162                         Turkey  23400            79.0   78300000     Asia
## 163                         Uganda   1690            61.6   40100000   Africa
## 164                        Ukraine   7470            71.9   44700000   Europe
## 165           United Arab Emirates  66000            76.5    9150000     Asia
## 166                 United Kingdom  38500            80.8   65400000   Europe
## 167                  United States  52800            78.8  320000000 Americas
## 168                        Uruguay  19800            77.1    3430000 Americas
## 169                     Uzbekistan   5700            70.0   31000000     Asia
## 170                        Vanuatu   2810            63.6     265000  Oceania
## 171                      Venezuela  15600            75.5   31200000 Americas
## 172                          Yemen   2640            67.2   26900000     Asia
## 173                         Zambia   3630            58.1   16100000   Africa
## 174                       Zimbabwe   1890            58.3   15800000   Africa
##                          sub.region year
## 1                     Southern Asia 2015
## 2                   Southern Europe 2015
## 3                   Northern Africa 2015
## 4                   Southern Europe 2015
## 5                Sub-Saharan Africa 2015
## 6   Latin America and the Caribbean 2015
## 7   Latin America and the Caribbean 2015
## 8                      Western Asia 2015
## 9         Australia and New Zealand 2015
## 10                   Western Europe 2015
## 11                     Western Asia 2015
## 12  Latin America and the Caribbean 2015
## 13                     Western Asia 2015
## 14                    Southern Asia 2015
## 15  Latin America and the Caribbean 2015
## 16                   Eastern Europe 2015
## 17                   Western Europe 2015
## 18  Latin America and the Caribbean 2015
## 19               Sub-Saharan Africa 2015
## 20                    Southern Asia 2015
## 21                  Southern Europe 2015
## 22               Sub-Saharan Africa 2015
## 23  Latin America and the Caribbean 2015
## 24                   Eastern Europe 2015
## 25               Sub-Saharan Africa 2015
## 26               Sub-Saharan Africa 2015
## 27               South-eastern Asia 2015
## 28               Sub-Saharan Africa 2015
## 29                 Northern America 2015
## 30               Sub-Saharan Africa 2015
## 31               Sub-Saharan Africa 2015
## 32  Latin America and the Caribbean 2015
## 33                     Eastern Asia 2015
## 34  Latin America and the Caribbean 2015
## 35               Sub-Saharan Africa 2015
## 36               Sub-Saharan Africa 2015
## 37  Latin America and the Caribbean 2015
## 38               Sub-Saharan Africa 2015
## 39                  Southern Europe 2015
## 40  Latin America and the Caribbean 2015
## 41                     Western Asia 2015
## 42                   Eastern Europe 2015
## 43                  Northern Europe 2015
## 44               Sub-Saharan Africa 2015
## 45  Latin America and the Caribbean 2015
## 46  Latin America and the Caribbean 2015
## 47  Latin America and the Caribbean 2015
## 48                  Northern Africa 2015
## 49  Latin America and the Caribbean 2015
## 50               Sub-Saharan Africa 2015
## 51               Sub-Saharan Africa 2015
## 52                  Northern Europe 2015
## 53               Sub-Saharan Africa 2015
## 54                        Melanesia 2015
## 55                  Northern Europe 2015
## 56                   Western Europe 2015
## 57               Sub-Saharan Africa 2015
## 58               Sub-Saharan Africa 2015
## 59                     Western Asia 2015
## 60                   Western Europe 2015
## 61               Sub-Saharan Africa 2015
## 62                  Southern Europe 2015
## 63  Latin America and the Caribbean 2015
## 64  Latin America and the Caribbean 2015
## 65               Sub-Saharan Africa 2015
## 66               Sub-Saharan Africa 2015
## 67  Latin America and the Caribbean 2015
## 68  Latin America and the Caribbean 2015
## 69  Latin America and the Caribbean 2015
## 70                   Eastern Europe 2015
## 71                  Northern Europe 2015
## 72                    Southern Asia 2015
## 73               South-eastern Asia 2015
## 74                     Western Asia 2015
## 75                  Northern Europe 2015
## 76                     Western Asia 2015
## 77                  Southern Europe 2015
## 78  Latin America and the Caribbean 2015
## 79                     Eastern Asia 2015
## 80                     Western Asia 2015
## 81               Sub-Saharan Africa 2015
## 82                       Micronesia 2015
## 83                     Western Asia 2015
## 84                     Central Asia 2015
## 85                  Northern Europe 2015
## 86                     Western Asia 2015
## 87               Sub-Saharan Africa 2015
## 88               Sub-Saharan Africa 2015
## 89                  Northern Africa 2015
## 90                  Northern Europe 2015
## 91                   Western Europe 2015
## 92               Sub-Saharan Africa 2015
## 93               Sub-Saharan Africa 2015
## 94               South-eastern Asia 2015
## 95                    Southern Asia 2015
## 96               Sub-Saharan Africa 2015
## 97                  Southern Europe 2015
## 98                       Micronesia 2015
## 99               Sub-Saharan Africa 2015
## 100              Sub-Saharan Africa 2015
## 101 Latin America and the Caribbean 2015
## 102                    Eastern Asia 2015
## 103                 Southern Europe 2015
## 104                 Northern Africa 2015
## 105              Sub-Saharan Africa 2015
## 106              South-eastern Asia 2015
## 107              Sub-Saharan Africa 2015
## 108                   Southern Asia 2015
## 109                  Western Europe 2015
## 110       Australia and New Zealand 2015
## 111 Latin America and the Caribbean 2015
## 112              Sub-Saharan Africa 2015
## 113              Sub-Saharan Africa 2015
## 114                    Eastern Asia 2015
## 115                 Northern Europe 2015
## 116                    Western Asia 2015
## 117                   Southern Asia 2015
## 118                    Western Asia 2015
## 119 Latin America and the Caribbean 2015
## 120                       Melanesia 2015
## 121 Latin America and the Caribbean 2015
## 122 Latin America and the Caribbean 2015
## 123              South-eastern Asia 2015
## 124                  Eastern Europe 2015
## 125                 Southern Europe 2015
## 126                    Western Asia 2015
## 127                  Eastern Europe 2015
## 128                  Eastern Europe 2015
## 129              Sub-Saharan Africa 2015
## 130                       Polynesia 2015
## 131              Sub-Saharan Africa 2015
## 132                    Western Asia 2015
## 133              Sub-Saharan Africa 2015
## 134                 Southern Europe 2015
## 135              Sub-Saharan Africa 2015
## 136              Sub-Saharan Africa 2015
## 137              South-eastern Asia 2015
## 138                  Eastern Europe 2015
## 139                 Southern Europe 2015
## 140                       Melanesia 2015
## 141              Sub-Saharan Africa 2015
## 142              Sub-Saharan Africa 2015
## 143                    Eastern Asia 2015
## 144              Sub-Saharan Africa 2015
## 145                 Southern Europe 2015
## 146                   Southern Asia 2015
## 147 Latin America and the Caribbean 2015
## 148 Latin America and the Caribbean 2015
## 149                 Northern Africa 2015
## 150 Latin America and the Caribbean 2015
## 151                 Northern Europe 2015
## 152                  Western Europe 2015
## 153                    Western Asia 2015
## 154                    Central Asia 2015
## 155              Sub-Saharan Africa 2015
## 156              South-eastern Asia 2015
## 157              South-eastern Asia 2015
## 158              Sub-Saharan Africa 2015
## 159                       Polynesia 2015
## 160 Latin America and the Caribbean 2015
## 161                 Northern Africa 2015
## 162                    Western Asia 2015
## 163              Sub-Saharan Africa 2015
## 164                  Eastern Europe 2015
## 165                    Western Asia 2015
## 166                 Northern Europe 2015
## 167                Northern America 2015
## 168 Latin America and the Caribbean 2015
## 169                    Central Asia 2015
## 170                       Melanesia 2015
## 171 Latin America and the Caribbean 2015
## 172                    Western Asia 2015
## 173              Sub-Saharan Africa 2015
## 174              Sub-Saharan Africa 2015
#making a ggplot
plot_LEIP <- ggplot(LEIP_f_15, aes(income, `life expectancy`))+geom_point(aes(color=country, size=pop_num))+ labs(x = "Income",y = "Life Expectancy", title = "Association between Income and Life Expectancy") 
#lot_LEIP
ggplotly(plot_LEIP)

Make an animated scatter plot that shows pattern of change in the relationship between life expectancy and income over the years. - Set the point size to be proportional to the population size - Use different colors for different regions. - can use a subset of years – I don’t have to use all the years available

plot_LEIP_99 <- ggplot(LEIP_f_99_18, aes(income, `life expectancy`))+geom_point(aes(color=region, size=pop_num), alpha=0.3)+ labs(title = 'Year: {frame_time}', x = "Income",y = "Life Expectancy")+transition_time(year)+ease_aes('linear')
animate(plot_LEIP_99)
## Warning: Removed 3 rows containing missing values (geom_point).
## Removed 3 rows containing missing values (geom_point).
## Removed 3 rows containing missing values (geom_point).
## Removed 3 rows containing missing values (geom_point).
## Removed 3 rows containing missing values (geom_point).
## Removed 3 rows containing missing values (geom_point).
## Removed 3 rows containing missing values (geom_point).
## Removed 3 rows containing missing values (geom_point).
## Removed 3 rows containing missing values (geom_point).
## Removed 3 rows containing missing values (geom_point).

anim_save('plot_LEIP_99.gif')